@echo off
echo Adding database and database user...
type Setup\USE.sql > ebas.sql

echo Adding tables...
type Tables\EBAS_VERSION.sql >> ebas.sql
type Tables\EBAS_LICENS.sql >> ebas.sql
type Tables\EBAS_SIKKERHED_OBJEKT_TYPE.sql >> ebas.sql
type Tables\EBAS_SIKKERHED_GRUPPE.sql >> ebas.sql
type Tables\EBAS_SIKKERHED_RETTIGHEDER.sql >> ebas.sql
type Tables\EBAS_STATUS.sql >> ebas.sql
type Tables\EBAS_IDENTIFIKATION.sql >> ebas.sql
type Tables\EBAS_BOGPAKKE.sql >> ebas.sql
type Tables\EBAS_ADRESSE_TYPE.sql >> ebas.sql
type Tables\EBAS_BOG.sql >> ebas.sql
type Tables\EBAS_POST_NR.sql >> ebas.sql
type Tables\EBAS_ADRESSE.sql >> ebas.sql
type Tables\EBAS_EJERFORHOLD.sql >> ebas.sql
type Tables\EBAS_FAKTURA_TYPE.sql >> ebas.sql
type Tables\EBAS_KARAKTER_SKALA.sql >> ebas.sql
type Tables\EBAS_KARAKTER.sql >> ebas.sql
type Tables\EBAS_FAG.sql >> ebas.sql
type Tables\EBAS_BOGPAKKE_BOG.sql >> ebas.sql
type Tables\EBAS_GRUPPE.sql >> ebas.sql
type Tables\EBAS_GRUPPE_FAG.sql >> ebas.sql
type Tables\EBAS_SIKKERHED_BRUGER.sql >> ebas.sql
type Tables\EBAS_STUDERENDE.sql >> ebas.sql
type Tables\EBAS_STUDERENDE_FAG.sql >> ebas.sql
type Tables\EBAS_DATO_NOTAT.sql >> ebas.sql
type Tables\EBAS_FAKTURA_DETALJE.sql >> ebas.sql
type Tables\EBAS_GRUPPE_STUDERENDE.sql >> ebas.sql
type Tables\EBAS_SIKKERHED_RELATION.sql >> ebas.sql
type Tables\EBAS_SIKKERHED_SESSION.sql >> ebas.sql
type Tables\EBAS_LOG.sql >> ebas.sql
type Tables\EBAS_STANDARD_VAERDI.sql >> ebas.sql

echo Adding data to tables...
type Data\EBAS_POSTNR_DATA.sql >> ebas.sql
type Data\EBAS_ADRESSE_DATA.sql >> ebas.sql

echo Adding functions...
type Functions\EBAS_F_SIKKERHED_HENT_RETTIGHED.sql >> ebas.sql
type Functions\EBAS_F_SIKKERHED_HENT_ADMIN_RETTIGHED.sql >> ebas.sql
type Functions\EBAS_F_SIKKERHED_VERIFICER_SESSION.sql >> ebas.sql

echo Adding procedures...
type Procedures\EBAS_SP_SIKKERHED_VERIFICER_SESSION.sql >> ebas.sql
type Procedures\EBAS_SP_SIKKERHED_SIGNON_BRUGER.sql >> ebas.sql
type Procedures\EBAS_SP_SIKKERHED_GIV_RETTIGHED.sql >> ebas.sql
type Procedures\EBAS_SP_SIKKERHED_NULSTIL.sql >> ebas.sql
type Procedures\EBAS_SP_SIKKERHED_SKIFT_KODE.sql >> ebas.sql
type Procedures\EBAS_SP_SIKKERHED_SIGNOFF_BRUGER.sql >> ebas.sql
type Procedures\EBAS_SP_HENT_IDENTIFIKATION_ALLE.sql >> ebas.sql
type Procedures\EBAS_SP_HENT_STATUS_ALLE.sql >> ebas.sql
type Procedures\EBAS_SP_OPRET_STUDERENDE.sql >> ebas.sql
type Procedures\EBAS_SP_FIND_STUDERENDE.sql >> ebas.sql
type Procedures\EBAS_SP_RET_STUDERENDE.sql >> ebas.sql
type Procedures\EBAS_SP_SLET_STUDERENDE.sql >> ebas.sql
type Procedures\EBAS_SP_HENT_EN_STUDERENDE.sql >> ebas.sql
type Procedures\EBAS_SP_HENT_SENESTE_FEJL.sql >> ebas.sql
type Procedures\EBAS_SP_HENT_LICENS_INFO.sql >> ebas.sql
type Procedures\EBAS_SP_GEM_LICENS_INFO.sql >> ebas.sql
type Procedures\EBAS_SP_HENT_POST_NR.sql >> ebas.sql
type Procedures\EBAS_SP_HENT_ADRESSE.sql >> ebas.sql
type Procedures\EBAS_SP_GEM_ADRESSE.sql >> ebas.sql
type Procedures\EBAS_SP_HENT_ADRESSE_TYPE_ALLE.sql >> ebas.sql
type Procedures\EBAS_SP_GEM_DATO_NOTAT.sql >> ebas.sql
type Procedures\EBAS_SP_HENT_DATO_NOTAT.sql >> ebas.sql
type Procedures\EBAS_SP_FIND_DATO_NOTAT.sql >> ebas.sql
type Procedures\EBAS_SP_HENT_STUDERENDE.sql >> ebas.sql
type Procedures\EBAS_SP_HENT_EJERFORHOLD.sql >> ebas.sql
type Procedures\EBAS_SP_GEM_EJERFORHOLD.sql >> ebas.sql
type Procedures\EBAS_SP_HENT_STANDARD_VAERDI.sql >> ebas.sql
type Procedures\EBAS_SP_GEM_GRUPPE.sql >> ebas.sql
type Procedures\EBAS_SP_HENT_GRUPPE.sql >> ebas.sql
type Procedures\EBAS_SP_HENT_GYLDIG_LICENSER.sql >> ebas.sql
type Procedures\EBAS_SP_SLET_GRUPPE.sql >> ebas.sql
type Procedures\EBAS_SP_TILMELD_STUDERENDE_GRUPPE.sql >> ebas.sql
type Procedures\EBAS_SP_AFMELD_STUDERENDE_GRUPPE.sql >> ebas.sql
type Procedures\EBAS_SP_HENT_MEDLEMMER.sql >> ebas.sql
type Procedures\EBAS_SP_TILMELD_FAG_GRUPPE.sql >> ebas.sql
type Procedures\EBAS_SP_AFMELD_FAG_GRUPPE.sql >> ebas.sql
type Procedures\EBAS_SP_HENT_FAG.sql >> ebas.sql
type Procedures\EBAS_SP_GEM_FAG.sql >> ebas.sql
type Procedures\EBAS_SP_SLET_FAG.sql >> ebas.sql
type Procedures\EBAS_SP_HENT_KARAKTER_SKALA.sql >> ebas.sql
type Procedures\EBAS_SP_SLET_KARAKTER_SKALA.sql >> ebas.sql
type Procedures\EBAS_SP_GEM_KARAKTER_SKALA.sql >> ebas.sql
type Procedures\EBAS_SP_SLET_BOGPAKKE.sql >> ebas.sql
type Procedures\EBAS_SP_GEM_BOGPAKKE.sql >> ebas.sql
type Procedures\EBAS_SP_HENT_BOGPAKKE.sql >> ebas.sql
type Procedures\EBAS_SP_GEM_BOG.sql >> ebas.sql
type Procedures\EBAS_SP_SLET_BOG.sql >> ebas.sql
type Procedures\EBAS_SP_HENT_BOG.sql >> ebas.sql
type Procedures\EBAS_SP_TILMELD_BOG_BOGPAKKE.sql >> ebas.sql
type Procedures\EBAS_SP_AFMELD_BOG_BOGPAKKE.sql >> ebas.sql
type Procedures\EBAS_SP_GEM_KARAKTER.sql >> ebas.sql
type Procedures\EBAS_SP_SLET_KARAKTER.sql >> ebas.sql
type Procedures\EBAS_SP_HENT_KARAKTER.sql >> ebas.sql
type Procedures\EBAS_SP_SLET_STATUS.sql >> ebas.sql
type Procedures\EBAS_SP_GEM_STATUS.sql >> ebas.sql
type Procedures\EBAS_SP_HENT_EJERFORHOLD_LEDER.sql >> ebas.sql
type Procedures\EBAS_SP_NULSTIL_ADGANGSKODE.sql >> ebas.sql

echo Script completed!
pause